RETRIEVE Statement
 ----------------------------------------------------------------------------


 Action

 Fetches the current record in an ISAM table and places its data into a
 record variable.


 Syntax


  RETRIEVE #  filenumber%,  recordvariable

 Remarks


  RETRIEVE places the current record's data into  recordvariable. You can
 change the data in  recordvariable, then update the current record with the
 changes you've made. Use the  UPDATE statement to update the current record.


 The  RETRIEVE statement uses the following arguments.

-----------------------------------------------------------------------------
 Argument                                Description
 Argument                                Description
 ----------------------------------------------------------------------------
  filenumber%                            The number used in the  OPEN
                                         statement to open the table.

  recordvariable                         The name of the variable that will
                                         hold the current record's data. It
                                         is a variable of the user-defined
                                         type  tabletype that was specified
                                         in the  OPEN statement.





  RETRIEVE has no effect on the current position.

 If the values passed to  recordvariable do not match the record strucure in
 the user-defined type, BASIC generates the error message Type Mismatch.The
 record structure includes the names and types of columns or fields.


 See Also

  INSERT,  UPDATE


 Example

 See the programming example for the  SEEKGT,  SEEKGE, and  SEEKEQ
 statements, which uses the  RETRIEVE statement.